// See the DataAccess setup code on the DataAccess class page.

// Executes a Select statement and retrieves the DataTable object.
private static void GetProcedureDataTable(DataAccess dataAccess)
{
  // Add(string parameterName, SqlDbType sqlDbType, int size
  //   , object value = null, ParameterDirection direction = ParameterDirection.Input)
  var parameters = new ProcedureParameters()
  {
    { "@ID", SqlDbType.Int, 0, 8 }
  };

  string procedureName = "dbo.sp_RetrieveByID";

  var dataTable = dataAccess.GetProcedureDataTable(procedureName
    , parameters);
  if (dataTable != null)
  {
    foreach (DataRow dataRow in dataTable.Rows)
    {
      for int index = 0; index < dataTable.Columns.Count; index++)
      {
        string value = dataRow[index].ToString();
      }
    }
  }
}